Manufacturing - Routing and Resources Tables

 

Column Name Column Type Length Default Value Description Enumeration
LaborTypeId nvarchar 10      
ScheduleId varchar 10      
HourlyRate pDecimal 13 0    
BillRate pDecimal 13 0    
BillMethod tinyint 1 0 Billing Method 1 = Pct over Cost, 2 = Hourly Rate
GLAcct1 pGlAcct 255      
PerPieceCost pDecimal 13 0    
MGID nvarchar 10      
CostGroupID nvarchar 6      
CF xml -1      
ts timestamp 8      
Descr pDescription 255      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
EmployeeId pEmpID 11      
LaborTypeId varchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
MachineGroupId nvarchar 10      
CostGroupId varchar 6      
ScheduleId varchar 10      
MaintCycle smallint 2 0    
MaintDate datetime 8      
QtyAvail smallint 2 0    
HrlyCostFactor pDecimal 13 0    
SetupTime pDecimal 13 0    
PurchaseDate datetime 8      
GLAcct1 pGlAcct 255      
MGID nvarchar 10      
CF xml -1      
ts timestamp 8      
Descr pDescription 255      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
MachineGroupId nvarchar 10      
LaborTypeId nvarchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
OperationId nvarchar 10      
QueueTime pDecimal 13 0    
QueueTimeIn smallint 2   Unit of Time - Queue Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MachSetup pDecimal 13 0    
MachSetupIn smallint 2   Unit of Time - Machine Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
LaborSetup pDecimal 13 0    
LaborSetupIn smallint 2   Unit of Time - Labor Setup Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MachRunTime pDecimal 13 0    
MachRunTimeIn smallint 2   Unit of Time - Machine Run Time 1 = Hours, 60 = Minutes, 3600 = Seconds
LaborRunTime pDecimal 13 0    
LaborRunTimeIn smallint 2   Unit of Time - Labor Run Time 1 = Hours, 60 = Minutes, 3600 = Seconds
WaitTime pDecimal 13 0    
WaitTimeIn smallint 2   Unit of Time - Wait Time 1 = Hours, 60 = Minutes, 3600 = Seconds
MoveTime pDecimal 13 0    
MoveTimeIn smallint 2   Unit of Time - Move Time 1 = Hours, 60 = Minutes, 3600 = Seconds
ReqEmployees tinyint 1 0    
MGID nvarchar 10      
DfltTo bit 1 0    
CF xml -1      
ts timestamp 8      
Descr pDescription 255      
LaborTypeId varchar 10      
MachineGroupId varchar 10      
MaxQuantity pDecimal 13      
Notes nvarchar max      
SetupLaborTypeId varchar 10      
Type tinyint 1   Operation Type 0 = Per Unit, 1 = Subcontract, 2 = Batch, 3 = Run Rate
WorkCenterId varchar 10      
YieldPct pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
OperationId varchar 10      
ToolingId varchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Descr pDescription 255      
Id int 4      
LaborTypeId varchar 10      
MachineGroupId varchar 10      
Notes nvarchar max      
OperationId varchar 10      
SetupLaborTypeId varchar 10      
Step int 4      
WorkCenterId varchar 10      
RoutingId nvarchar 10      
OverlapYn bit 1 0    
MGID nvarchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RoutingId nvarchar 10      
Descr pDescription 255      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RoutingId varchar 10      
ToolingId varchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Descr pDescription 255      
Id varchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
ScheduleId varchar 10      
BeginDate datetime 8      
DayValue tinyint 1   Day Value 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday
Descr pDescription 255      
EndDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
ScheduleDateId int 4      
BeginTime int 4 0    
Duration int 4 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
OperationId nvarchar 10      
VendorId pVendorID 10      
CostGroupId varchar 10      
UnitCost pDecimal 13 0    
LeadTime int 4 0    
MinQty int 4 0    
MGID nvarchar 10      
DfltVendorId bit 1 -1    
GLAcct1 pGlAcct 255      
CF xml -1      
ts timestamp 8      
Descr pDescription 255      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
ToolingId nvarchar 10      
Qty pDecimal 13 0    
VendorId pVendorID 10      
Cost pDecimal 13 0    
StorageLocation nvarchar 10      
Consumable bit 1      
MGID nvarchar 10      
CF xml -1      
ts timestamp 8      
Descr pDescription 255      
Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
WorkCenterId nvarchar 10      
MachineGroupId nvarchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
WorkCenterId nvarchar 10      
CostGroupId varchar 6      
ScheduleId varchar 10      
GLAcct1 pGlAcct 255      
Super nvarchar 30      
BillRate pDecimal 13 0    
BillMethod tinyint 1 0 Billing Method 1 = Pct over Cost, 2 = Hourly Rate
OverheadLaborPct pDecimal 13 0    
OverheadFlatAmt pDecimal 13 0    
OverheadPerPiece pDecimal 13 0    
OverheadMachPct pDecimal 13 0    
MGID nvarchar 10      
CF xml -1      
ts timestamp 8      
Descr pDescription 255      
Notes nvarchar max